| Check Constraint Name |
CheckConstraint |
| Chk_FaApproveDisbCriteria_MinCumulativeGPAFlag_MinCumulativeGPA |
([MinCumulativeGPAFlag] = 1 and [MinCumulativeGPA] > 0 or [MinCumulativeGPAFlag] = 0 and [MinCumulativeGPA] = 0) |
| Chk_FaApproveDisbCriteria_MinNumAvgFlag_MinNumAvg |
([MinNumAvgFlag] = 1 and [MinNumAvg] > 0 or [MinNumAvgFlag] = 0 and [MinNumAvg] = 0) |
| Chk_FaApproveDisbCriteria_MinHoursAttFlag_MinHoursAtt |
([MinHoursAttFlag] = 1 and [MinHoursAtt] > 0 or [MinHoursAttFlag] = 0 and [MinHoursAtt] = 0) |
| Chk_FaApproveDisbCriteria_MinPctAttFlag_MinPctAtt |
([MinPctAttFlag] = 1 and [MinPctAtt] > 0 or [MinPctAttFlag] = 0 and [MinPctAtt] = 0) |
| Chk_MinHoursCreditsSchedFlag_MinHoursSched_MinCreditsSched |
([MinHoursCreditsSchedFlag] = 1 and ([MinHoursSched] > 0 or [MinCreditsSched] > 0) or [MinHoursCreditsSchedFlag] = 0 and ([MinHoursSched] = 0 and [MinCreditsSched] = 0)) |
| Chk_MinHoursCreditsCompFlag_MinHoursSched_MinCreditsComp |
([MinHoursCreditsCompFlag] = 1 and ([MinHoursComp] > 0 or [MinCreditsComp] > 0) or [MinHoursCreditsCompFlag] = 0 and ([MinHoursComp] = 0 and [MinCreditsComp] = 0)) |
| Chk_FaApproveDisbCriteria_MaxDaysFromLoanEndDateFlag_MaxDaysFromLoanEndDate |
([MaxDaysFromLoanEndDateFlag] = 1 and [MaxDaysFromLoanEndDate] >= 0 or [MaxDaysFromLoanEndDateFlag] = 0 and [MaxDaysFromLoanEndDate] = 0) |
| Chk_FaApproveDisbCriteria_MaxDiffDisbAmtFlag_MaxDiffDisbAmt |
([MaxDiffDisbAmtFlag] = 1 and [MaxDiffDisbAmt] >= 0 or [MaxDiffDisbAmtFlag] = 0 and [MaxDiffDisbAmt] = 0) |
| Chk_FaApproveDisbCriteria_MaxDaysAfterStudLDAFlag_MaxDaysAfterStudLDA |
([MaxDaysAfterStudLDAFlag] = 1 and [MaxDaysAfterStudLDA] >= 0 or [MaxDaysAfterStudLDAFlag] = 0 and [MaxDaysAfterStudLDAFlag] = 0) |